UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7dzobnaIDHUMmy9GyIm/tDl/D0VmI0JjF+exY8X6awU='
WHERE
key_id = '48221af1b21b0093b654d8983ef51d59cd86d8ce51f29e44d16b4aee28236652'
AND (
token = '7dzobnaIDHUMmy9GyIm/tDl/D0VmI0JjF+exY8X6awU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)