UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7uGsnLwJkU+AZbqEEo99vD1v8h9wmStnVBYFtZOG5s4='
WHERE
key_id = '3146dbd4127940eb02d444b069d3ca9fe7b9b777e42687859e7f9a1a51c55fc3'
AND (
token = '7uGsnLwJkU+AZbqEEo99vD1v8h9wmStnVBYFtZOG5s4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)