UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9Tay5qUh5W0qXhzekx7oKMwSpYVcsV67JyOgnL4Cdqw='
WHERE
key_id = 'b210a03a856ea3c658d9f9569d309beec49cfe42a2efb2a98c1a36ef46785538'
AND (
token = '9Tay5qUh5W0qXhzekx7oKMwSpYVcsV67JyOgnL4Cdqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)