UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BsajXtC1W83FQYz4Q1vOC3Y1dXE3wSb7ChgsIDasMTA='
WHERE
key_id = '60e0a6787a10d2bb41376d6d3a6bec7a701d7458487ffe2785430039b8d7f8df'
AND (
token = 'BsajXtC1W83FQYz4Q1vOC3Y1dXE3wSb7ChgsIDasMTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)