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