UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '36iTk/T3u3KjoehH1+lI1Qx+UioU+QjUfE1i96c9JLw='
WHERE
key_id = 'd46ea27e1767667fd16b289ce510ae978f658660f37342e64d85e5b628c35eae'
AND (
token = '36iTk/T3u3KjoehH1+lI1Qx+UioU+QjUfE1i96c9JLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)