UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XwAYC8HiRyzjS67bUTYcjC7xISkOc61dbfYSIKSFZMo='
WHERE
key_id = '7ca30fb2243eed7ecd5a334db5ce3aa62e8f96000dff734c4de997e997f8095f'
AND (
token = 'XwAYC8HiRyzjS67bUTYcjC7xISkOc61dbfYSIKSFZMo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)