UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G3MCE1LrK80paid2Ez1eYCp896pjo13jonxCMiF6WEY='
WHERE
key_id = '792aca622cee4468d4c2e765b0b87f4554a5eec486fddf56b944482b5c9468a5'
AND (
token = 'G3MCE1LrK80paid2Ez1eYCp896pjo13jonxCMiF6WEY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)