UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRFTgxxFZ+ZNW9jyoSeUIFN7MMz1GYOPJpgrhb0Sc/U='
WHERE
key_id = '52827b0b5a13e628c0dd2300d443a32e4cbb3934f592d35a5b41e44a21ea18a0'
AND (
token = 'pRFTgxxFZ+ZNW9jyoSeUIFN7MMz1GYOPJpgrhb0Sc/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)