UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XgYYxP50eYsQ42cni40+Jb7WYoSbhVp3Mu33KwrKkrc='
WHERE
key_id = '1a9b64f603621d447a3713edcb8b70edd929019feb7dd217f803ccc438af8923'
AND (
token = 'XgYYxP50eYsQ42cni40+Jb7WYoSbhVp3Mu33KwrKkrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)