UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4/Lu3EmB5xubgiS0jTKZqYWVePph6WbcXYe3J3a9+yg=' 
WHERE 
  key_id = '1471ba27734835b5abb655fc3feb05176001e2dd903e49aab64d1e8dbd175b5b' 
  AND (
    token = '4/Lu3EmB5xubgiS0jTKZqYWVePph6WbcXYe3J3a9+yg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026