UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hMSsxoy4JOphWy+QU/1lg2B1oH+yeWDUR/+cChZ+Fhk='
WHERE
key_id = 'c4fb84de3f99fa7dac1e5e8a71590489df61821951772fcd86b557710f5274bd'
AND (
token = 'hMSsxoy4JOphWy+QU/1lg2B1oH+yeWDUR/+cChZ+Fhk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)