UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ie42+trFd07K9LbawSA+lhV9c5EFyk6MIn7byz/PnRU='
WHERE
key_id = 'b27d855f9ee76a2a96982553e056273251be9b65869e6664c7d0d64c686cf16d'
AND (
token = 'ie42+trFd07K9LbawSA+lhV9c5EFyk6MIn7byz/PnRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)