UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GzMR7UIj/MwctHORYNbEFAKk49c5D0fgDNItWQe5Srk='
WHERE
key_id = '1a18b6437dfb83ed2b0b4d6c6c402f6ad6f68a66ad701d2b4a217a5c3a68128d'
AND (
token = 'GzMR7UIj/MwctHORYNbEFAKk49c5D0fgDNItWQe5Srk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)