UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VBNO7vUuC/bR5V4tQZNsL7LHgUPytoB6bPU5lEGMSbU='
WHERE
key_id = '0812b81cfcbce6ad8a15deeeac934877f5b35fab2f472cb82a651cab8c25b3a3'
AND (
token = 'VBNO7vUuC/bR5V4tQZNsL7LHgUPytoB6bPU5lEGMSbU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)