UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7AKmVOaSzZYPXdFd8oQMhEvVpkKDMkyzbbqAJuahzY='
WHERE
key_id = '54cae4aa47b783e3a23f5b766f9d8b276f50cab7b6ab1a77ab4aa1b0a5203dac'
AND (
token = 'a7AKmVOaSzZYPXdFd8oQMhEvVpkKDMkyzbbqAJuahzY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)