UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4ZNnLK294W46kJwkNK6nf8j8CbqP+Q8mHzMKrHfqOIg=' 
WHERE 
  key_id = 'e752cf8c6bf234564ef11d69be30c806105f7c893c065a19d854eb2213f9ff50' 
  AND (
    token = '4ZNnLK294W46kJwkNK6nf8j8CbqP+Q8mHzMKrHfqOIg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027