UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VaEv2dCMsRjLmGZpB7fhGz1EL81GiRpog9Xh6mBNMp4='
WHERE
key_id = 'ebf95a71493c999cd58982708cc5f4e610b39efb90d173de24b0a9e0635b3a25'
AND (
token = 'VaEv2dCMsRjLmGZpB7fhGz1EL81GiRpog9Xh6mBNMp4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)