UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lf1S6Pe1huCWAovnVuG/4nNqvMgWOj3IKhMyjeSk4Qc='
WHERE
key_id = 'eb89ba87518a3f54704ff7fb4becbfc7e01ae53134906bb8e4e66b5e70027a9c'
AND (
token = 'lf1S6Pe1huCWAovnVuG/4nNqvMgWOj3IKhMyjeSk4Qc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)