UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vUQ1HIHTxQyk7dLwEdsu2oi1kHh/4sXSBlisK88vfTw='
WHERE
key_id = 'c2cf497555f9f87233faa6a10e91806b2bfe60e990b94c4a9b04befdd5e0d712'
AND (
token = 'vUQ1HIHTxQyk7dLwEdsu2oi1kHh/4sXSBlisK88vfTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)