UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YHXeacmBcYpL+OhbRIYZ/Y2PjWfX7we/tkd3Bfysgfk='
WHERE
key_id = 'ddb5567c82ad7e47d67c1be556b77324ebca97a7fcb9a236f8cd65369400a095'
AND (
token = 'YHXeacmBcYpL+OhbRIYZ/Y2PjWfX7we/tkd3Bfysgfk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)