UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BQGv9AMZrtkImPC7UW4jkPKOmOFY1/pe2RD4DgQgjYA='
WHERE
key_id = '2a5e8698af6524f6f0ada55c3b82e73cb65d150daf3dbda4b152dd2e789c8d20'
AND (
token = 'BQGv9AMZrtkImPC7UW4jkPKOmOFY1/pe2RD4DgQgjYA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)