UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N+TdGT9+dbTPn0HUNZIIbZM5NW6CnFrAx4ZnmsOYlNo='
WHERE
key_id = 'd1b6fe918f8fd0bc836075b9cdac9ff9b5e3d619be1f3f1eccee258fb642dab2'
AND (
token = 'N+TdGT9+dbTPn0HUNZIIbZM5NW6CnFrAx4ZnmsOYlNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)