UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JAavC8WBIBbqWAimZozmMQ1HDQsEWp9jO5As4qZZEOs='
WHERE
key_id = 'dc848b9a87e83de8ba14d66edb6def8973a97e76158e91f53ac1c6aa748fcdc5'
AND (
token = 'JAavC8WBIBbqWAimZozmMQ1HDQsEWp9jO5As4qZZEOs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)