UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UiXQoXdQGdSQcGHJEwR0xeGr9OG9AjgAGlBwTebMwuo='
WHERE
key_id = 'aff1cd0a64118f8b49aace070fd507c39e35ec711d41630b7132f4f3bb9d2e02'
AND (
token = 'UiXQoXdQGdSQcGHJEwR0xeGr9OG9AjgAGlBwTebMwuo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)