UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V8dF5oTIwuIxKYi0mwGit57V3u3gL3H9pUH5aXBq3q8='
WHERE
key_id = '6b367900095282aef72fa64ceb355ef9096580d15280af79abaf36be72dbf768'
AND (
token = 'V8dF5oTIwuIxKYi0mwGit57V3u3gL3H9pUH5aXBq3q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)