UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3WdUk7Bx7s2dgRV/vv5df+flXqtqey8zVG/LNpzV+hs='
WHERE
key_id = '1b4f550c864cc28ff984f75b76ca0912ce7fd88d65adff9d835d53b0a00ab727'
AND (
token = '3WdUk7Bx7s2dgRV/vv5df+flXqtqey8zVG/LNpzV+hs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)