UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2QaNxnpJUph0h/zsgv5dSlVrgzZzX+3Pi8dNz38Dsaw='
WHERE
key_id = 'd3ff1a1ae917ca85e1e162a71ccc0599cf3026d9314ba1e62d6fcb836b697967'
AND (
token = '2QaNxnpJUph0h/zsgv5dSlVrgzZzX+3Pi8dNz38Dsaw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)