UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZjM8P5HfLPXprvhNi6cp9e7F9uwfuFmRXPCxqEbs70M='
WHERE
key_id = '06d15dede883981b17daf715312239d5725719fb0d0727392709919fef4e35b3'
AND (
token = 'ZjM8P5HfLPXprvhNi6cp9e7F9uwfuFmRXPCxqEbs70M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)