UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jJYD9Jo4pS3IWYpLZ6HfcojLUS48SSvrD+t0KUprtzU='
WHERE
key_id = '19406a11c386cc159e5c194253805555457f59a39256afb3902c89e6f4167253'
AND (
token = 'jJYD9Jo4pS3IWYpLZ6HfcojLUS48SSvrD+t0KUprtzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)