UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k9OGGaNIfKADA2MVSHNrltX7GeFVNUzuyfK9vgGKatk='
WHERE
key_id = 'c6e0fb9854242778c0144806ff413d98fdcc8ebe4ff125ad3d0b4a59bc04e478'
AND (
token = 'k9OGGaNIfKADA2MVSHNrltX7GeFVNUzuyfK9vgGKatk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)