UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3rxGE9ewn47T2q6Gba4Xta1KvqsqlPlGSXGDQLYS6cc='
WHERE
key_id = 'd9a0b5d9ee93721d867844ac596a53b001c9ded8c3380007037e07e5982964e7'
AND (
token = '3rxGE9ewn47T2q6Gba4Xta1KvqsqlPlGSXGDQLYS6cc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)