UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LkGhrwE9BIsBiU/cHkH1Bp6PPjDDZqWURPjFLQiR0mw='
WHERE
key_id = 'a2ae5e2ed6b672af618d326986f5940490116601098db461dfbd3835a38291a7'
AND (
token = 'LkGhrwE9BIsBiU/cHkH1Bp6PPjDDZqWURPjFLQiR0mw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)