UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3AzKehOa/8QWvrm0xah8f6yxqImiZJ2sC1aMiBPc5PU='
WHERE
key_id = 'f96420d44616f99acf73f7ad916e253a0a65611a0107e141c3645c5c232c607c'
AND (
token = '3AzKehOa/8QWvrm0xah8f6yxqImiZJ2sC1aMiBPc5PU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)